參考內容推薦

SQL Server In Memory Tables

Unlike standard tables, memory-optimized tables require a special filegroup to handle durability (checkpoint files). Even though the data is in memory, we need a place on disk to store the transaction logs so we don’t lose data if the power goes out

memoryoptimizedtable

Unlikestandardtables,memory-optimizedtablesrequireaspecialfilegrouptohandledurability(checkpointfiles).Eventhoughthedataisinmemory,weneedaplaceondisktostorethetransactionlogssowedon’tlosedataifthepowergoesout